<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.13"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>webmysql: src/java/org/dbcloud/jdbc/Statement.java Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="csmake.v2.100.png"/></td>
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">webmysql
   &#160;<span id="projectnumber">1.0</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.13 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
</script>
<div id="main-nav"></div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('jdbc_2_statement_8java_source.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">Statement.java</div>  </div>
</div><!--header-->
<div class="contents">
<div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="comment">/*</span></div><div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment"> * Copyright (c) 2017, dbcloud.org and/or its affiliates. All rights reserved.</span></div><div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> * Use is subject to license terms.</span></div><div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> */</span></div><div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="keyword">package </span>org.dbcloud.jdbc;</div><div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;</div><div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="keyword">import</span> java.sql.Connection;</div><div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="keyword">import</span> java.sql.DriverManager;</div><div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="keyword">import</span> java.sql.ResultSet;</div><div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="keyword">import</span> java.sql.ResultSetMetaData;</div><div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="keyword">import</span> java.sql.SQLException;</div><div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="keyword">import</span> java.sql.SQLFeatureNotSupportedException;</div><div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="keyword">import</span> java.sql.SQLWarning;</div><div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="keyword">import</span> java.util.ArrayList;</div><div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="keyword">import</span> java.util.List;</div><div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="keyword">import</span> <a class="code" href="namespaceorg.html">org</a>.bson.Document;</div><div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;</div><div class="line"><a name="l00036"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">   36</a></span>&#160;<span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">Statement</a> {</div><div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;</div><div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;    <span class="keyword">private</span> java.sql.Statement stmt;</div><div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;    <span class="keyword">private</span> Connection con = null;</div><div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;    <span class="keyword">private</span> String conString = <span class="stringliteral">&quot;&quot;</span>;</div><div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;</div><div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;    <span class="keyword">public</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">Statement</a>() {</div><div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;    }</div><div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;</div><div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;    <span class="keyword">public</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">Statement</a>(String driverClass, String connection) <span class="keywordflow">throws</span> ClassNotFoundException, SQLException {  </div><div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;        <span class="keywordflow">try</span> {</div><div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;            conString = connection;</div><div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;            Class.forName(driverClass);</div><div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;            this.con = DriverManager.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afb6b2eeae90afbd7fdecf399cda5a9eb">getConnection</a>(connection);</div><div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;            stmt = con.createStatement();</div><div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;        } <span class="keywordflow">catch</span> (Exception ex) {</div><div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;            System.err.println(ex.toString());</div><div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160;            <span class="keywordflow">throw</span> ex;</div><div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;        }</div><div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;    }</div><div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;</div><div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;    <span class="keyword">public</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">Statement</a>(String driverClass, String connection, String user, String password) <span class="keywordflow">throws</span> ClassNotFoundException, SQLException {</div><div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;        <span class="keywordflow">try</span> {</div><div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;            conString = connection;</div><div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;            Class.forName(driverClass);</div><div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;            this.con = DriverManager.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afb6b2eeae90afbd7fdecf399cda5a9eb">getConnection</a>(connection, user, password);</div><div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;            stmt = con.createStatement();</div><div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;        } <span class="keywordflow">catch</span> (Exception ex) {</div><div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;            System.err.println(ex.toString());</div><div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;            <span class="keywordflow">throw</span> ex;</div><div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;        }</div><div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;    }</div><div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;</div><div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> csmakeInit(java.util.HashMap&lt;String, String&gt; args) <span class="keywordflow">throws</span> Exception {</div><div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;        <span class="keywordflow">if</span> (args.containsKey(<span class="stringliteral">&quot;driver&quot;</span>) &amp;&amp; args.containsKey(<span class="stringliteral">&quot;connection&quot;</span>)) {</div><div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;            conString = args.get(<span class="stringliteral">&quot;connection&quot;</span>);</div><div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;            Class.forName(args.get(<span class="stringliteral">&quot;driver&quot;</span>));</div><div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;</div><div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;            <span class="keywordflow">if</span> (args.containsKey(<span class="stringliteral">&quot;user&quot;</span>) &amp;&amp; args.containsKey(<span class="stringliteral">&quot;password&quot;</span>)) {</div><div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;                this.con = DriverManager.getConnection(conString, args.get(<span class="stringliteral">&quot;user&quot;</span>), args.get(<span class="stringliteral">&quot;password&quot;</span>));</div><div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;            } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;                this.con = DriverManager.getConnection(conString);</div><div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;            }</div><div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;            stmt = con.createStatement();</div><div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;        }</div><div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;    }</div><div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;</div><div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;    <span class="keyword">private</span> ArrayList&lt;Document&gt; getColumns(<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> rs) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;        ResultSetMetaData columns = rs.getMetaData();</div><div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;        <span class="keywordtype">int</span> columnsCount = columns.getColumnCount();</div><div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;        ArrayList&lt;Document&gt; header = <span class="keyword">new</span> ArrayList();</div><div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;        <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 1; i &lt;= columnsCount; i++) {</div><div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;            Document doc = <span class="keyword">new</span> Document();</div><div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;            String name = columns.getColumnName(i);</div><div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;            doc.append(<span class="stringliteral">&quot;name&quot;</span>, name);</div><div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;            String label = columns.getColumnLabel(i);</div><div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;            <span class="keywordflow">if</span> (label != null &amp;&amp; !label.isEmpty()) {</div><div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;                doc.append(<span class="stringliteral">&quot;label&quot;</span>, label);</div><div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;            }</div><div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;            String className = columns.getColumnClassName(i);</div><div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;            <span class="keywordflow">if</span> (className != null &amp;&amp; !className.isEmpty()) {</div><div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;                doc.append(<span class="stringliteral">&quot;className&quot;</span>, className);</div><div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;            }</div><div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;            String typeName = columns.getColumnTypeName(i);</div><div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;            <span class="keywordflow">if</span> (typeName != null &amp;&amp; !typeName.isEmpty()) {</div><div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;                doc.append(<span class="stringliteral">&quot;typeName&quot;</span>, typeName);</div><div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;            }</div><div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;            String schemaName = columns.getSchemaName(i);</div><div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;            <span class="keywordflow">if</span> (schemaName != null &amp;&amp; !schemaName.isEmpty()) {</div><div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;                doc.append(<span class="stringliteral">&quot;schemaName&quot;</span>, schemaName);</div><div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;            }</div><div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;            String tableName = columns.getTableName(i);</div><div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;            <span class="keywordflow">if</span> (tableName != null &amp;&amp; !tableName.isEmpty()) {</div><div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;                doc.append(<span class="stringliteral">&quot;tableName&quot;</span>, tableName);</div><div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;            }</div><div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;            header.add(doc);</div><div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;        }</div><div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;        <span class="keywordflow">return</span> header;</div><div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;    }</div><div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;</div><div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;    <span class="keyword">private</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> convResultSet(<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> rs, <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result, Document options) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;        <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;            <span class="keywordflow">if</span> (options.getBoolean(<span class="stringliteral">&quot;document&quot;</span>, <span class="keyword">false</span>)) {</div><div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;                ArrayList&lt;Object&gt; list = <span class="keyword">new</span> ArrayList();</div><div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;                ResultSetMetaData columns = rs.getMetaData();</div><div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;                result.columns=getColumns(rs);</div><div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;                <span class="keywordtype">int</span> columnsCount = columns.getColumnCount();</div><div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;                <span class="keywordflow">while</span> (rs.next()) {</div><div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;                    Document doc = <span class="keyword">new</span> Document();</div><div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;                    <span class="comment">// read the result set</span></div><div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;                    <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 1; i &lt;= columnsCount; i++) {</div><div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;                        String name = columns.getColumnName(i);</div><div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;                        doc.append(name, rs.getObject(i));</div><div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;                    }</div><div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;                    list.add(doc);</div><div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;                }</div><div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;                result.rows= list;</div><div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;            } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;                ArrayList columns = getColumns(rs);</div><div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;                <span class="keywordtype">int</span> columnsCount = columns.size();</div><div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;                result.columns= columns;</div><div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;                ArrayList&lt;Object&gt; rows = <span class="keyword">new</span> ArrayList();</div><div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;                <span class="keywordflow">while</span> (rs.next()) {</div><div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;</div><div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;                    <span class="comment">// read the result set</span></div><div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;                    ArrayList&lt;Object&gt; cells = <span class="keyword">new</span> ArrayList();</div><div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;                    <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 1; i &lt;= columnsCount; i++) {</div><div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;                        cells.add(rs.getObject(i));</div><div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;                    }</div><div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;                    rows.add(cells);</div><div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;                }</div><div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;                result.rows=rows;</div><div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;            }</div><div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;            rs.close();</div><div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;            rs = null;</div><div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;        }</div><div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;    }</div><div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;</div><div class="line"><a name="l00172"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">  172</a></span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">executeQuery</a>(String sql) {</div><div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;        <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> rs = null;</div><div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;        <span class="keywordflow">try</span> {</div><div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;            rs = stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">executeQuery</a>(sql);</div><div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;            <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;                convResultSet(rs, result, <span class="keyword">new</span> Document());</div><div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;                rs = null;</div><div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;            }</div><div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;        } <span class="keywordflow">catch</span> (SQLException e) {</div><div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;            <span class="comment">// if the error message is &quot;out of memory&quot;, </span></div><div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;            <span class="comment">// it probably means no database file is found</span></div><div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;            result.error= <span class="keyword">new</span> Document(<span class="stringliteral">&quot;message&quot;</span>, e.getMessage()).append(<span class="stringliteral">&quot;code&quot;</span>, e.getErrorCode()).append(<span class="stringliteral">&quot;SQLState&quot;</span>, e.getSQLState());</div><div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;            System.err.println(e.getMessage());</div><div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;        } <span class="keywordflow">finally</span> {</div><div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;            <span class="keywordflow">try</span> {</div><div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;                <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;                    rs.close();</div><div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;                }</div><div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;            } <span class="keywordflow">catch</span> (SQLException e) {</div><div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;                <span class="comment">// connection close failed.</span></div><div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;                System.err.println(e);</div><div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;            }</div><div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;        }</div><div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;    }</div><div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;</div><div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">executeQuery</a>(String sql, Document options) {</div><div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;        <span class="keywordflow">if</span> (options.getBoolean(<span class="stringliteral">&quot;document&quot;</span>, <span class="keyword">false</span>)) {</div><div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;            <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> rs = null;</div><div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;            <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;            <span class="keywordflow">try</span> {</div><div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;                ArrayList&lt;Document&gt; list = <span class="keyword">new</span> ArrayList();</div><div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;                rs = stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">executeQuery</a>(sql);</div><div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;                <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;                    convResultSet(rs, result, options);</div><div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;                    rs = null;</div><div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;                }</div><div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;            } <span class="keywordflow">catch</span> (SQLException e) {</div><div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;                <span class="comment">// if the error message is &quot;out of memory&quot;, </span></div><div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;                <span class="comment">// it probably means no database file is found</span></div><div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;                System.err.println(e.getMessage());</div><div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;                result.error=<span class="keyword">new</span> Document(<span class="stringliteral">&quot;message&quot;</span>, e.getMessage()).append(<span class="stringliteral">&quot;code&quot;</span>, e.getErrorCode()).append(<span class="stringliteral">&quot;SQLState&quot;</span>, e.getSQLState());</div><div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;            } <span class="keywordflow">finally</span> {</div><div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;                <span class="keywordflow">try</span> {</div><div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;                    <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;                        rs.close();</div><div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;                    }</div><div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;                } <span class="keywordflow">catch</span> (SQLException e) {</div><div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;                    <span class="comment">// connection close failed.</span></div><div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160;                    System.err.println(e);</div><div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;                }</div><div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;            }</div><div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;            <span class="keywordflow">return</span> result;</div><div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;        } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">executeQuery</a>(sql);</div><div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;        }</div><div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;    }</div><div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;</div><div class="line"><a name="l00243"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a005f0da4c3d9beb59caa27fbb6fe02c3">  243</a></span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a005f0da4c3d9beb59caa27fbb6fe02c3">executeProcedure</a>(String procedureName, Document parameters, Document options) {</div><div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;</div><div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;        <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> rs = null;</div><div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> resultDocument = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;        java.sql.CallableStatement callableStatement = null;</div><div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;        String callString = null;</div><div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;</div><div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;        <span class="keywordflow">try</span> {</div><div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;            <span class="keywordtype">int</span> parameterCount = 0;</div><div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;            <span class="keywordflow">if</span> (parameters != null) {</div><div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;                parameterCount = parameters.size();</div><div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;            }</div><div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;            <span class="comment">// &lt;editor-fold desc=&quot;构造callString&quot;&gt;</span></div><div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;            StringBuilder callStringBuilder = null;</div><div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;            <span class="keywordflow">if</span> (parameterCount &gt; 0) {</div><div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;                callStringBuilder = <span class="keyword">new</span> StringBuilder();</div><div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;                <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 0; i &lt; parameterCount; i++) {</div><div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;                    <span class="keywordflow">if</span> (callStringBuilder.length() == 0) {</div><div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;                        callStringBuilder.append(<span class="stringliteral">&quot;?&quot;</span>);</div><div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;                    } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;                        callStringBuilder.append(<span class="stringliteral">&quot;,?&quot;</span>);</div><div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;                    }</div><div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;                }</div><div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;            }</div><div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;            <span class="keywordflow">if</span> (callStringBuilder != null) {</div><div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;                callString = <span class="stringliteral">&quot;{call &quot;</span> + procedureName + <span class="stringliteral">&quot;(&quot;</span> + callStringBuilder.toString() + <span class="stringliteral">&quot;)}&quot;</span>;</div><div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;            } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;                callString = <span class="stringliteral">&quot;{call &quot;</span> + procedureName + <span class="stringliteral">&quot; }&quot;</span>;</div><div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;            }</div><div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;</div><div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;            <span class="comment">// &lt;/editor-fold&gt;</span></div><div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;            callableStatement = this.con.prepareCall(callString);</div><div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;</div><div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;            <span class="comment">// &lt;editor-fold desc=&quot;向callableStatement设置参数值&quot;&gt;</span></div><div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;            <span class="keywordtype">int</span> i = 0;</div><div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;            <span class="keywordflow">for</span> (String parameterName : parameters.keySet()) {</div><div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;                Document parameter = parameters.get(parameterName, Document.class);</div><div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;                String parameterDirection = parameter.getString(<span class="stringliteral">&quot;Direction&quot;</span>); <span class="comment">//in or out</span></div><div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;                <span class="keywordflow">if</span> (parameterDirection == <span class="stringliteral">&quot;out&quot;</span>) {</div><div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;                    callableStatement.registerOutParameter(i + 1, parameter.getInteger(<span class="stringliteral">&quot;SqlType&quot;</span>));</div><div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;                } <span class="keywordflow">else</span> {</div><div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;                    <span class="keywordtype">int</span> sqlType = parameter.getInteger(<span class="stringliteral">&quot;SqlType&quot;</span>);</div><div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;</div><div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;                    <span class="keywordflow">if</span> (sqlType == java.sql.Types.INTEGER) {</div><div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;                        callableStatement.setInt(i + 1, parameter.getInteger(<span class="stringliteral">&quot;Value&quot;</span>));</div><div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.BIGINT) {</div><div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;                        callableStatement.setLong(i + 1, parameter.getLong(<span class="stringliteral">&quot;Value&quot;</span>));</div><div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.NVARCHAR || sqlType == java.sql.Types.VARCHAR) {</div><div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;                        callableStatement.setString(i + 1, parameter.getString(<span class="stringliteral">&quot;Value&quot;</span>));</div><div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.DOUBLE) {</div><div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;                        callableStatement.setDouble(i + 1, parameter.getDouble(<span class="stringliteral">&quot;Value&quot;</span>));</div><div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.TIMESTAMP) {</div><div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;                        <span class="keywordflow">try</span> {</div><div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;                            callableStatement.setTimestamp(i + 1, parameter.get(<span class="stringliteral">&quot;Value&quot;</span>, java.sql.Timestamp.class)); <span class="comment">//需要测试 </span></div><div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;                        } <span class="keywordflow">catch</span> (Exception castExcep) {</div><div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;                            String exString = castExcep.toString();</div><div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;                        }</div><div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.BOOLEAN) {</div><div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;                        callableStatement.setBoolean(i + 1, parameter.getBoolean(<span class="stringliteral">&quot;Value&quot;</span>));</div><div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;                    }</div><div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;                }</div><div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;                i++;</div><div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;            }</div><div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;            <span class="comment">// &lt;/editor-fold&gt;</span></div><div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;</div><div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;            callableStatement.execute();</div><div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;</div><div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;            <span class="comment">// &lt;editor-fold desc=&quot;处理输出参数&quot;&gt;</span></div><div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;            i = 0;</div><div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;            <span class="keywordflow">for</span> (String parameterName : parameters.keySet()) {</div><div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;                Document parameter = parameters.get(parameterName, Document.class);</div><div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;                String parameterDirection = parameter.getString(<span class="stringliteral">&quot;Direction&quot;</span>); <span class="comment">//in or out</span></div><div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;                <span class="keywordtype">int</span> sqlType = parameter.getInteger(<span class="stringliteral">&quot;SqlType&quot;</span>);</div><div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;                <span class="keywordflow">if</span> (parameterDirection == <span class="stringliteral">&quot;out&quot;</span>) {</div><div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;                    <span class="keywordflow">if</span> (sqlType == java.sql.Types.INTEGER) {</div><div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getInt(i + 1));</div><div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.BIGINT) {</div><div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getLong(i + 1));</div><div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.DOUBLE) {</div><div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getDouble(i + 1));</div><div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.FLOAT) {</div><div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getFloat(i + 1));</div><div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.VARCHAR || sqlType == java.sql.Types.NVARCHAR) {</div><div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getString(i + 1));</div><div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;                    } <span class="keywordflow">else</span> <span class="keywordflow">if</span> (sqlType == java.sql.Types.BOOLEAN) {</div><div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;                        parameter.put(<span class="stringliteral">&quot;OutValue&quot;</span>, callableStatement.getBoolean(i + 1));</div><div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;                    }</div><div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;                }</div><div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;                i++;</div><div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;            }</div><div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;</div><div class="line"><a name="l00334"></a><span class="lineno">  334</span>&#160;            <span class="comment">// &lt;/editor-fold&gt;</span></div><div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;            rs = callableStatement.getResultSet();</div><div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;            <span class="keywordflow">if</span> (rs != null) {</div><div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;                convResultSet(rs, resultDocument, options);</div><div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;                rs.close();</div><div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160;                rs = null;</div><div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;            }</div><div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;        } <span class="keywordflow">catch</span> (Exception e) {</div><div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;            <span class="comment">// &lt;editor-fold desc=&quot;异常处理&quot;&gt;</span></div><div class="line"><a name="l00343"></a><span class="lineno">  343</span>&#160;            String strLog = <span class="stringliteral">&quot;execCSTMTNonQuery&quot;</span> + callString;</div><div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;            <span class="keywordtype">int</span> i = 0;</div><div class="line"><a name="l00345"></a><span class="lineno">  345</span>&#160;            <span class="keywordflow">for</span> (String parameterName : parameters.keySet()) {</div><div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;                Document parameter = parameters.get(parameterName, Document.class);</div><div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;                String parameterDirection = parameter.getString(<span class="stringliteral">&quot;Direction&quot;</span>); <span class="comment">//in or out</span></div><div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;                <span class="keywordtype">int</span> sqlType = parameter.getInteger(<span class="stringliteral">&quot;SqlType&quot;</span>);</div><div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160;</div><div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;                strLog = strLog + <span class="stringliteral">&quot;\r\n????&quot;</span> + (i + 1);</div><div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;</div><div class="line"><a name="l00352"></a><span class="lineno">  352</span>&#160;                strLog = strLog + <span class="stringliteral">&quot;inout=&quot;</span> + parameterDirection;</div><div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;                strLog = strLog + <span class="stringliteral">&quot;parameterType=&quot;</span> + sqlType;</div><div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;                strLog = strLog + <span class="stringliteral">&quot;in=&quot;</span> + parameter.get(<span class="stringliteral">&quot;Value&quot;</span>);</div><div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160;                strLog = strLog + <span class="stringliteral">&quot; out=&quot;</span> + parameter.get(<span class="stringliteral">&quot;OutValue&quot;</span>);</div><div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160;</div><div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;                i++;</div><div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;            }</div><div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160;            <span class="comment">// &lt;/editor-fold&gt;</span></div><div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;        } <span class="keywordflow">finally</span> {</div><div class="line"><a name="l00361"></a><span class="lineno">  361</span>&#160;            <span class="comment">// &lt;editor-fold desc=&quot;释放资源&quot;&gt;</span></div><div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160;            <span class="keywordflow">try</span> {</div><div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;                callableStatement.close();</div><div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160;            } <span class="keywordflow">catch</span> (Exception ex) {</div><div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160;                <span class="comment">//log.error(&quot;CLOSE CALLABLESTAMENT &quot;, ex);  </span></div><div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;            }</div><div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160;            callableStatement = null;</div><div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;            <span class="comment">// &lt;/editor-fold&gt;</span></div><div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160;        }</div><div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;        <span class="keywordflow">return</span> resultDocument;</div><div class="line"><a name="l00371"></a><span class="lineno">  371</span>&#160;    }</div><div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;</div><div class="line"><a name="l00397"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">  397</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(String sql) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(sql);</div><div class="line"><a name="l00399"></a><span class="lineno">  399</span>&#160;    }</div><div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;</div><div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span>[] <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(String[] sqls) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;        <span class="keywordflow">for</span> (String sql : sqls) {</div><div class="line"><a name="l00403"></a><span class="lineno">  403</span>&#160;            stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">addBatch</a>(sql);</div><div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160;        }</div><div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">executeBatch</a>();</div><div class="line"><a name="l00406"></a><span class="lineno">  406</span>&#160;    }</div><div class="line"><a name="l00407"></a><span class="lineno">  407</span>&#160;</div><div class="line"><a name="l00423"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aa80c2e0e1085aac839151b8872e16993">  423</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aa80c2e0e1085aac839151b8872e16993">close</a>() throws SQLException {</div><div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aa80c2e0e1085aac839151b8872e16993">close</a>();</div><div class="line"><a name="l00425"></a><span class="lineno">  425</span>&#160;        con.close();</div><div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;    }</div><div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160;</div><div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160;    <span class="comment">//----------------------------------------------------------------------</span></div><div class="line"><a name="l00445"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a74ee124d251a1785b5ee72461d992cee">  445</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a74ee124d251a1785b5ee72461d992cee">getMaxFieldSize</a>() throws SQLException {</div><div class="line"><a name="l00446"></a><span class="lineno">  446</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a74ee124d251a1785b5ee72461d992cee">getMaxFieldSize</a>();</div><div class="line"><a name="l00447"></a><span class="lineno">  447</span>&#160;    }</div><div class="line"><a name="l00448"></a><span class="lineno">  448</span>&#160;</div><div class="line"><a name="l00468"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a266653054fac9255337fba5c1460ae75">  468</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a266653054fac9255337fba5c1460ae75">setMaxFieldSize</a>(<span class="keywordtype">int</span> max) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00469"></a><span class="lineno">  469</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a266653054fac9255337fba5c1460ae75">setMaxFieldSize</a>(max);</div><div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;    }</div><div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160;</div><div class="line"><a name="l00484"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a08d8bad6ab34257c4d0a110c36a78616">  484</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a08d8bad6ab34257c4d0a110c36a78616">getMaxRows</a>() throws SQLException {</div><div class="line"><a name="l00485"></a><span class="lineno">  485</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a08d8bad6ab34257c4d0a110c36a78616">getMaxRows</a>();</div><div class="line"><a name="l00486"></a><span class="lineno">  486</span>&#160;    }</div><div class="line"><a name="l00487"></a><span class="lineno">  487</span>&#160;</div><div class="line"><a name="l00500"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a62eea46adeee8609b3e1a47e11aa5870">  500</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a62eea46adeee8609b3e1a47e11aa5870">setMaxRows</a>(<span class="keywordtype">int</span> max) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00501"></a><span class="lineno">  501</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a62eea46adeee8609b3e1a47e11aa5870">setMaxRows</a>(max);</div><div class="line"><a name="l00502"></a><span class="lineno">  502</span>&#160;    }</div><div class="line"><a name="l00503"></a><span class="lineno">  503</span>&#160;</div><div class="line"><a name="l00526"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9015df745c62b658704417ff162bf981">  526</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9015df745c62b658704417ff162bf981">setEscapeProcessing</a>(<span class="keywordtype">boolean</span> enable) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00527"></a><span class="lineno">  527</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9015df745c62b658704417ff162bf981">setEscapeProcessing</a>(enable);</div><div class="line"><a name="l00528"></a><span class="lineno">  528</span>&#160;    }</div><div class="line"><a name="l00529"></a><span class="lineno">  529</span>&#160;</div><div class="line"><a name="l00541"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a09a3a60330f32ae3182494583e4bb18a">  541</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a09a3a60330f32ae3182494583e4bb18a">getQueryTimeout</a>() throws SQLException {</div><div class="line"><a name="l00542"></a><span class="lineno">  542</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a09a3a60330f32ae3182494583e4bb18a">getQueryTimeout</a>();</div><div class="line"><a name="l00543"></a><span class="lineno">  543</span>&#160;    }</div><div class="line"><a name="l00544"></a><span class="lineno">  544</span>&#160;</div><div class="line"><a name="l00571"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afe5aa6911f700fbe2437ac7a62abf507">  571</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afe5aa6911f700fbe2437ac7a62abf507">setQueryTimeout</a>(<span class="keywordtype">int</span> seconds) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00572"></a><span class="lineno">  572</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afe5aa6911f700fbe2437ac7a62abf507">setQueryTimeout</a>(seconds);</div><div class="line"><a name="l00573"></a><span class="lineno">  573</span>&#160;    }</div><div class="line"><a name="l00574"></a><span class="lineno">  574</span>&#160;</div><div class="line"><a name="l00585"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adb34cc908e3ce0eb251f82d61172dce8">  585</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adb34cc908e3ce0eb251f82d61172dce8">cancel</a>() throws SQLException {</div><div class="line"><a name="l00586"></a><span class="lineno">  586</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adb34cc908e3ce0eb251f82d61172dce8">cancel</a>();</div><div class="line"><a name="l00587"></a><span class="lineno">  587</span>&#160;    }</div><div class="line"><a name="l00588"></a><span class="lineno">  588</span>&#160;</div><div class="line"><a name="l00611"></a><span class="lineno">  611</span>&#160;    SQLWarning getWarnings() <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00612"></a><span class="lineno">  612</span>&#160;        <span class="keywordflow">return</span> stmt.getWarnings();</div><div class="line"><a name="l00613"></a><span class="lineno">  613</span>&#160;    }</div><div class="line"><a name="l00614"></a><span class="lineno">  614</span>&#160;</div><div class="line"><a name="l00624"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a1d2ec18e122dcc8e7f12b0c561ffab17">  624</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a1d2ec18e122dcc8e7f12b0c561ffab17">clearWarnings</a>() throws SQLException {</div><div class="line"><a name="l00625"></a><span class="lineno">  625</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a1d2ec18e122dcc8e7f12b0c561ffab17">clearWarnings</a>();</div><div class="line"><a name="l00626"></a><span class="lineno">  626</span>&#160;    }</div><div class="line"><a name="l00627"></a><span class="lineno">  627</span>&#160;</div><div class="line"><a name="l00652"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a02375dec95831d0c7d2f4879d2502110">  652</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a02375dec95831d0c7d2f4879d2502110">setCursorName</a>(String name) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00653"></a><span class="lineno">  653</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a02375dec95831d0c7d2f4879d2502110">setCursorName</a>(name);</div><div class="line"><a name="l00654"></a><span class="lineno">  654</span>&#160;    }</div><div class="line"><a name="l00655"></a><span class="lineno">  655</span>&#160;</div><div class="line"><a name="l00656"></a><span class="lineno">  656</span>&#160;    <span class="comment">//----------------------- Multiple Results --------------------------</span></div><div class="line"><a name="l00688"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">  688</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(String sql) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00689"></a><span class="lineno">  689</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(sql);</div><div class="line"><a name="l00690"></a><span class="lineno">  690</span>&#160;    }</div><div class="line"><a name="l00691"></a><span class="lineno">  691</span>&#160;</div><div class="line"><a name="l00692"></a><span class="lineno">  692</span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span>[] <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(String[] sqls) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00693"></a><span class="lineno">  693</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9427303d199c8b15f023c2e5746f7a03">clearBatch</a>();</div><div class="line"><a name="l00694"></a><span class="lineno">  694</span>&#160;        <span class="keywordflow">for</span> (String sql : sqls) {</div><div class="line"><a name="l00695"></a><span class="lineno">  695</span>&#160;            stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">addBatch</a>(sql);</div><div class="line"><a name="l00696"></a><span class="lineno">  696</span>&#160;        }</div><div class="line"><a name="l00697"></a><span class="lineno">  697</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">executeBatch</a>();</div><div class="line"><a name="l00698"></a><span class="lineno">  698</span>&#160;    }</div><div class="line"><a name="l00699"></a><span class="lineno">  699</span>&#160;</div><div class="line"><a name="l00711"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">  711</a></span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">getResultSet</a>() throws SQLException {</div><div class="line"><a name="l00712"></a><span class="lineno">  712</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l00713"></a><span class="lineno">  713</span>&#160;        convResultSet(stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">getResultSet</a>(), result, <span class="keyword">new</span> Document());</div><div class="line"><a name="l00714"></a><span class="lineno">  714</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l00715"></a><span class="lineno">  715</span>&#160;    }</div><div class="line"><a name="l00716"></a><span class="lineno">  716</span>&#160;</div><div class="line"><a name="l00717"></a><span class="lineno">  717</span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">getResultSet</a>(Document options) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00718"></a><span class="lineno">  718</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l00719"></a><span class="lineno">  719</span>&#160;        convResultSet(stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">getResultSet</a>(), result, options);</div><div class="line"><a name="l00720"></a><span class="lineno">  720</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l00721"></a><span class="lineno">  721</span>&#160;    }</div><div class="line"><a name="l00722"></a><span class="lineno">  722</span>&#160;</div><div class="line"><a name="l00734"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ac0ebb00942f335fd306d6f0e7e8b09c5">  734</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ac0ebb00942f335fd306d6f0e7e8b09c5">getUpdateCount</a>() throws SQLException {</div><div class="line"><a name="l00735"></a><span class="lineno">  735</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ac0ebb00942f335fd306d6f0e7e8b09c5">getUpdateCount</a>();</div><div class="line"><a name="l00736"></a><span class="lineno">  736</span>&#160;    }</div><div class="line"><a name="l00737"></a><span class="lineno">  737</span>&#160;</div><div class="line"><a name="l00758"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43ca3bf24baedb67bf63710ff837f72d">  758</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43ca3bf24baedb67bf63710ff837f72d">getMoreResults</a>() throws SQLException {</div><div class="line"><a name="l00759"></a><span class="lineno">  759</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43ca3bf24baedb67bf63710ff837f72d">getMoreResults</a>();</div><div class="line"><a name="l00760"></a><span class="lineno">  760</span>&#160;    }</div><div class="line"><a name="l00761"></a><span class="lineno">  761</span>&#160;</div><div class="line"><a name="l00762"></a><span class="lineno">  762</span>&#160;    <span class="comment">//--------------------------Statement 2.0-----------------------------</span></div><div class="line"><a name="l00782"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a63fddc3f05f3ecf12cf3f13a413888ea">  782</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a63fddc3f05f3ecf12cf3f13a413888ea">setFetchDirection</a>(<span class="keywordtype">int</span> direction) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00783"></a><span class="lineno">  783</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a63fddc3f05f3ecf12cf3f13a413888ea">setFetchDirection</a>(direction);</div><div class="line"><a name="l00784"></a><span class="lineno">  784</span>&#160;    }</div><div class="line"><a name="l00785"></a><span class="lineno">  785</span>&#160;</div><div class="line"><a name="l00800"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a38206e2c79afc6ce964f1b058c20d12f">  800</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a38206e2c79afc6ce964f1b058c20d12f">getFetchDirection</a>() throws SQLException {</div><div class="line"><a name="l00801"></a><span class="lineno">  801</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a38206e2c79afc6ce964f1b058c20d12f">getFetchDirection</a>();</div><div class="line"><a name="l00802"></a><span class="lineno">  802</span>&#160;    }</div><div class="line"><a name="l00803"></a><span class="lineno">  803</span>&#160;</div><div class="line"><a name="l00818"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a401b7cbfca595b070210b0e8672c2b56">  818</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a401b7cbfca595b070210b0e8672c2b56">setFetchSize</a>(<span class="keywordtype">int</span> rows) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00819"></a><span class="lineno">  819</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a401b7cbfca595b070210b0e8672c2b56">setFetchSize</a>(rows);</div><div class="line"><a name="l00820"></a><span class="lineno">  820</span>&#160;    }</div><div class="line"><a name="l00821"></a><span class="lineno">  821</span>&#160;</div><div class="line"><a name="l00836"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a37fe1abd43d17fd845faa1925170e99a">  836</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a37fe1abd43d17fd845faa1925170e99a">getFetchSize</a>() throws SQLException {</div><div class="line"><a name="l00837"></a><span class="lineno">  837</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a37fe1abd43d17fd845faa1925170e99a">getFetchSize</a>();</div><div class="line"><a name="l00838"></a><span class="lineno">  838</span>&#160;    }</div><div class="line"><a name="l00839"></a><span class="lineno">  839</span>&#160;</div><div class="line"><a name="l00850"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43715d383be3fb5d2ee030668bfc6221">  850</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43715d383be3fb5d2ee030668bfc6221">getResultSetConcurrency</a>() throws SQLException {</div><div class="line"><a name="l00851"></a><span class="lineno">  851</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43715d383be3fb5d2ee030668bfc6221">getResultSetConcurrency</a>();</div><div class="line"><a name="l00852"></a><span class="lineno">  852</span>&#160;    }</div><div class="line"><a name="l00853"></a><span class="lineno">  853</span>&#160;</div><div class="line"><a name="l00865"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a743ed7694dd8a9a67b2c23319db6ca3e">  865</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a743ed7694dd8a9a67b2c23319db6ca3e">getResultSetType</a>() throws SQLException {</div><div class="line"><a name="l00866"></a><span class="lineno">  866</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a743ed7694dd8a9a67b2c23319db6ca3e">getResultSetType</a>();</div><div class="line"><a name="l00867"></a><span class="lineno">  867</span>&#160;    }</div><div class="line"><a name="l00868"></a><span class="lineno">  868</span>&#160;</div><div class="line"><a name="l00887"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">  887</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">addBatch</a>(String sql) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l00888"></a><span class="lineno">  888</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">addBatch</a>(sql);</div><div class="line"><a name="l00889"></a><span class="lineno">  889</span>&#160;    }</div><div class="line"><a name="l00890"></a><span class="lineno">  890</span>&#160;</div><div class="line"><a name="l00902"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9427303d199c8b15f023c2e5746f7a03">  902</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9427303d199c8b15f023c2e5746f7a03">clearBatch</a>() throws SQLException {</div><div class="line"><a name="l00903"></a><span class="lineno">  903</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9427303d199c8b15f023c2e5746f7a03">clearBatch</a>();</div><div class="line"><a name="l00904"></a><span class="lineno">  904</span>&#160;    }</div><div class="line"><a name="l00905"></a><span class="lineno">  905</span>&#160;</div><div class="line"><a name="l00960"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">  960</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span>[] <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">executeBatch</a>() throws SQLException {</div><div class="line"><a name="l00961"></a><span class="lineno">  961</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">executeBatch</a>();</div><div class="line"><a name="l00962"></a><span class="lineno">  962</span>&#160;    }</div><div class="line"><a name="l00963"></a><span class="lineno">  963</span>&#160;</div><div class="line"><a name="l00973"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afb6b2eeae90afbd7fdecf399cda5a9eb">  973</a></span>&#160;    <span class="keyword">public</span> String <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afb6b2eeae90afbd7fdecf399cda5a9eb">getConnection</a>() throws SQLException {</div><div class="line"><a name="l00974"></a><span class="lineno">  974</span>&#160;        <span class="keywordflow">return</span> conString;</div><div class="line"><a name="l00975"></a><span class="lineno">  975</span>&#160;    }</div><div class="line"><a name="l00976"></a><span class="lineno">  976</span>&#160;</div><div class="line"><a name="l00977"></a><span class="lineno">  977</span>&#160;    <span class="comment">//--------------------------Statement 3.0-----------------------------</span></div><div class="line"><a name="l00984"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afa7b4b2c3acd383591999842acb0d6c3">  984</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afa7b4b2c3acd383591999842acb0d6c3">CLOSE_CURRENT_RESULT</a> = 1;</div><div class="line"><a name="l00985"></a><span class="lineno">  985</span>&#160;</div><div class="line"><a name="l00992"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acf23cba800d36c519344e01581aedc9f">  992</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acf23cba800d36c519344e01581aedc9f">KEEP_CURRENT_RESULT</a> = 2;</div><div class="line"><a name="l00993"></a><span class="lineno">  993</span>&#160;</div><div class="line"><a name="l01001"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#abffb2fa787f9c6d14484a8d545c4a161"> 1001</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#abffb2fa787f9c6d14484a8d545c4a161">CLOSE_ALL_RESULTS</a> = 3;</div><div class="line"><a name="l01002"></a><span class="lineno"> 1002</span>&#160;</div><div class="line"><a name="l01009"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a2bff6ca86fe1ed08d3a52ade6b1b7240"> 1009</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a2bff6ca86fe1ed08d3a52ade6b1b7240">SUCCESS_NO_INFO</a> = -2;</div><div class="line"><a name="l01010"></a><span class="lineno"> 1010</span>&#160;</div><div class="line"><a name="l01017"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acfa84224f98ccf395c3568a0f882eb35"> 1017</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acfa84224f98ccf395c3568a0f882eb35">EXECUTE_FAILED</a> = -3;</div><div class="line"><a name="l01018"></a><span class="lineno"> 1018</span>&#160;</div><div class="line"><a name="l01025"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a348a9c2612c65ebc810d3f043f382766"> 1025</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a348a9c2612c65ebc810d3f043f382766">RETURN_GENERATED_KEYS</a> = 1;</div><div class="line"><a name="l01026"></a><span class="lineno"> 1026</span>&#160;</div><div class="line"><a name="l01033"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4e6170daf48535ddaff70a77c701acdc"> 1033</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4e6170daf48535ddaff70a77c701acdc">NO_GENERATED_KEYS</a> = 2;</div><div class="line"><a name="l01034"></a><span class="lineno"> 1034</span>&#160;</div><div class="line"><a name="l01069"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a982c5f8902932b29d8de9dee0d57e275"> 1069</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a982c5f8902932b29d8de9dee0d57e275">getMoreResults</a>(<span class="keywordtype">int</span> current) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01070"></a><span class="lineno"> 1070</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43ca3bf24baedb67bf63710ff837f72d">getMoreResults</a>(current);</div><div class="line"><a name="l01071"></a><span class="lineno"> 1071</span>&#160;    }</div><div class="line"><a name="l01072"></a><span class="lineno"> 1072</span>&#160;</div><div class="line"><a name="l01092"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586"> 1092</a></span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586">getGeneratedKeys</a>() throws SQLException {</div><div class="line"><a name="l01093"></a><span class="lineno"> 1093</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l01094"></a><span class="lineno"> 1094</span>&#160;        convResultSet(stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586">getGeneratedKeys</a>(), result, <span class="keyword">new</span> Document());</div><div class="line"><a name="l01095"></a><span class="lineno"> 1095</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l01096"></a><span class="lineno"> 1096</span>&#160;    }</div><div class="line"><a name="l01097"></a><span class="lineno"> 1097</span>&#160;</div><div class="line"><a name="l01098"></a><span class="lineno"> 1098</span>&#160;    <span class="keyword">public</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586">getGeneratedKeys</a>(Document options) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01099"></a><span class="lineno"> 1099</span>&#160;        <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a> result = <span class="keyword">new</span> <a class="code" href="namespaceorg.html">org</a>.<a class="code" href="namespaceorg_1_1dbcloud.html">dbcloud</a>.<a class="code" href="namespaceorg_1_1dbcloud_1_1jdbc.html">jdbc</a>.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">ResultSet</a>();</div><div class="line"><a name="l01100"></a><span class="lineno"> 1100</span>&#160;        convResultSet(stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586">getGeneratedKeys</a>(), result, options);</div><div class="line"><a name="l01101"></a><span class="lineno"> 1101</span>&#160;        <span class="keywordflow">return</span> result;</div><div class="line"><a name="l01102"></a><span class="lineno"> 1102</span>&#160;    }</div><div class="line"><a name="l01103"></a><span class="lineno"> 1103</span>&#160;</div><div class="line"><a name="l01139"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a0e6028a45786c2efbddc440852a0afc7"> 1139</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a0e6028a45786c2efbddc440852a0afc7">executeUpdate</a>(String sql, <span class="keywordtype">int</span> autoGeneratedKeys) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01140"></a><span class="lineno"> 1140</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(sql, autoGeneratedKeys);</div><div class="line"><a name="l01141"></a><span class="lineno"> 1141</span>&#160;    }</div><div class="line"><a name="l01142"></a><span class="lineno"> 1142</span>&#160;</div><div class="line"><a name="l01174"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae56b5f32aeed201dc64139f130627215"> 1174</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae56b5f32aeed201dc64139f130627215">executeUpdate</a>(String sql, <span class="keywordtype">int</span> columnIndexes[]) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01175"></a><span class="lineno"> 1175</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(sql, columnIndexes);</div><div class="line"><a name="l01176"></a><span class="lineno"> 1176</span>&#160;    }</div><div class="line"><a name="l01177"></a><span class="lineno"> 1177</span>&#160;</div><div class="line"><a name="l01212"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afc1d222a53d4503e85fb86a05e7e5985"> 1212</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afc1d222a53d4503e85fb86a05e7e5985">executeUpdate</a>(String sql, String columnNames[]) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01213"></a><span class="lineno"> 1213</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">executeUpdate</a>(sql, columnNames);</div><div class="line"><a name="l01214"></a><span class="lineno"> 1214</span>&#160;    }</div><div class="line"><a name="l01215"></a><span class="lineno"> 1215</span>&#160;</div><div class="line"><a name="l01264"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a5fc6ab488a578bd789a94108e5c21c9f"> 1264</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a5fc6ab488a578bd789a94108e5c21c9f">execute</a>(String sql, <span class="keywordtype">int</span> autoGeneratedKeys) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01265"></a><span class="lineno"> 1265</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(sql, autoGeneratedKeys);</div><div class="line"><a name="l01266"></a><span class="lineno"> 1266</span>&#160;    }</div><div class="line"><a name="l01267"></a><span class="lineno"> 1267</span>&#160;</div><div class="line"><a name="l01317"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a41f483314ed5dcbc787a74bb824eb3ad"> 1317</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a41f483314ed5dcbc787a74bb824eb3ad">execute</a>(String sql, <span class="keywordtype">int</span> columnIndexes[]) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01318"></a><span class="lineno"> 1318</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(sql, columnIndexes);</div><div class="line"><a name="l01319"></a><span class="lineno"> 1319</span>&#160;    }</div><div class="line"><a name="l01320"></a><span class="lineno"> 1320</span>&#160;</div><div class="line"><a name="l01370"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a158b6739f9b0b40fa61ebf9e5447fbec"> 1370</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a158b6739f9b0b40fa61ebf9e5447fbec">execute</a>(String sql, String columnNames[]) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01371"></a><span class="lineno"> 1371</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">execute</a>(sql, columnNames);</div><div class="line"><a name="l01372"></a><span class="lineno"> 1372</span>&#160;    }</div><div class="line"><a name="l01373"></a><span class="lineno"> 1373</span>&#160;</div><div class="line"><a name="l01385"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a910dad307d541945796b5c9cc20331f0"> 1385</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a910dad307d541945796b5c9cc20331f0">getResultSetHoldability</a>() throws SQLException {</div><div class="line"><a name="l01386"></a><span class="lineno"> 1386</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a910dad307d541945796b5c9cc20331f0">getResultSetHoldability</a>();</div><div class="line"><a name="l01387"></a><span class="lineno"> 1387</span>&#160;    }</div><div class="line"><a name="l01388"></a><span class="lineno"> 1388</span>&#160;</div><div class="line"><a name="l01399"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a238a99b288bf216e85c15ef4f5146afb"> 1399</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a238a99b288bf216e85c15ef4f5146afb">isClosed</a>() throws SQLException {</div><div class="line"><a name="l01400"></a><span class="lineno"> 1400</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a238a99b288bf216e85c15ef4f5146afb">isClosed</a>();</div><div class="line"><a name="l01401"></a><span class="lineno"> 1401</span>&#160;    }</div><div class="line"><a name="l01402"></a><span class="lineno"> 1402</span>&#160;</div><div class="line"><a name="l01425"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adc015a991c336f0edea9e26c0de37027"> 1425</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adc015a991c336f0edea9e26c0de37027">setPoolable</a>(<span class="keywordtype">boolean</span> poolable)</div><div class="line"><a name="l01426"></a><span class="lineno"> 1426</span>&#160;            <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01427"></a><span class="lineno"> 1427</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adc015a991c336f0edea9e26c0de37027">setPoolable</a>(poolable);</div><div class="line"><a name="l01428"></a><span class="lineno"> 1428</span>&#160;    }</div><div class="line"><a name="l01429"></a><span class="lineno"> 1429</span>&#160;</div><div class="line"><a name="l01444"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aebe85c4f946f983a1e36b816f999f4a3"> 1444</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aebe85c4f946f983a1e36b816f999f4a3">isPoolable</a>()</div><div class="line"><a name="l01445"></a><span class="lineno"> 1445</span>&#160;            throws SQLException {</div><div class="line"><a name="l01446"></a><span class="lineno"> 1446</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aebe85c4f946f983a1e36b816f999f4a3">isPoolable</a>();</div><div class="line"><a name="l01447"></a><span class="lineno"> 1447</span>&#160;    }</div><div class="line"><a name="l01448"></a><span class="lineno"> 1448</span>&#160;</div><div class="line"><a name="l01449"></a><span class="lineno"> 1449</span>&#160;    <span class="comment">//--------------------------Statement 4.1 -----------------------------</span></div><div class="line"><a name="l01465"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a8074a7dca69e29eeac5c5db676588b5f"> 1465</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a8074a7dca69e29eeac5c5db676588b5f">closeOnCompletion</a>() throws SQLException {</div><div class="line"><a name="l01466"></a><span class="lineno"> 1466</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a8074a7dca69e29eeac5c5db676588b5f">closeOnCompletion</a>();</div><div class="line"><a name="l01467"></a><span class="lineno"> 1467</span>&#160;    }</div><div class="line"><a name="l01468"></a><span class="lineno"> 1468</span>&#160;</div><div class="line"><a name="l01479"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a631da85a6cab87cfac1920fa97df3abd"> 1479</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a631da85a6cab87cfac1920fa97df3abd">isCloseOnCompletion</a>() throws SQLException {</div><div class="line"><a name="l01480"></a><span class="lineno"> 1480</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a631da85a6cab87cfac1920fa97df3abd">isCloseOnCompletion</a>();</div><div class="line"><a name="l01481"></a><span class="lineno"> 1481</span>&#160;    }</div><div class="line"><a name="l01482"></a><span class="lineno"> 1482</span>&#160;</div><div class="line"><a name="l01483"></a><span class="lineno"> 1483</span>&#160;    <span class="comment">//--------------------------Statement 4.2 -----------------------------</span></div><div class="line"><a name="l01502"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9dda16f528c3730e94d251457e353956"> 1502</a></span>&#160;<span class="comment"></span>    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9dda16f528c3730e94d251457e353956">getLargeUpdateCount</a>() throws SQLException {</div><div class="line"><a name="l01503"></a><span class="lineno"> 1503</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9dda16f528c3730e94d251457e353956">getLargeUpdateCount</a>();</div><div class="line"><a name="l01504"></a><span class="lineno"> 1504</span>&#160;    }</div><div class="line"><a name="l01505"></a><span class="lineno"> 1505</span>&#160;</div><div class="line"><a name="l01525"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ad9a6cb92f183850a7d06973be471e177"> 1525</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ad9a6cb92f183850a7d06973be471e177">setLargeMaxRows</a>(<span class="keywordtype">long</span> max) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01526"></a><span class="lineno"> 1526</span>&#160;        stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ad9a6cb92f183850a7d06973be471e177">setLargeMaxRows</a>(max);</div><div class="line"><a name="l01527"></a><span class="lineno"> 1527</span>&#160;    }</div><div class="line"><a name="l01528"></a><span class="lineno"> 1528</span>&#160;</div><div class="line"><a name="l01547"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a29c2090bbc4b542346d008011a12218b"> 1547</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a29c2090bbc4b542346d008011a12218b">getLargeMaxRows</a>() throws SQLException {</div><div class="line"><a name="l01548"></a><span class="lineno"> 1548</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a29c2090bbc4b542346d008011a12218b">getLargeMaxRows</a>();</div><div class="line"><a name="l01549"></a><span class="lineno"> 1549</span>&#160;    }</div><div class="line"><a name="l01550"></a><span class="lineno"> 1550</span>&#160;</div><div class="line"><a name="l01606"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a04d00ffd335a8da75bf6dc51f4913f88"> 1606</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span>[] <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a04d00ffd335a8da75bf6dc51f4913f88">executeLargeBatch</a>() throws SQLException {</div><div class="line"><a name="l01607"></a><span class="lineno"> 1607</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a04d00ffd335a8da75bf6dc51f4913f88">executeLargeBatch</a>();</div><div class="line"><a name="l01608"></a><span class="lineno"> 1608</span>&#160;    }</div><div class="line"><a name="l01609"></a><span class="lineno"> 1609</span>&#160;</div><div class="line"><a name="l01641"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a"> 1641</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">executeLargeUpdate</a>(String sql) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01642"></a><span class="lineno"> 1642</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">executeLargeUpdate</a>(sql);</div><div class="line"><a name="l01643"></a><span class="lineno"> 1643</span>&#160;    }</div><div class="line"><a name="l01644"></a><span class="lineno"> 1644</span>&#160;</div><div class="line"><a name="l01686"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a453afff67167062d34d5780538ff0c55"> 1686</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a453afff67167062d34d5780538ff0c55">executeLargeUpdate</a>(String sql, <span class="keywordtype">int</span> autoGeneratedKeys)</div><div class="line"><a name="l01687"></a><span class="lineno"> 1687</span>&#160;            <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01688"></a><span class="lineno"> 1688</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">executeLargeUpdate</a>(sql, autoGeneratedKeys);</div><div class="line"><a name="l01689"></a><span class="lineno"> 1689</span>&#160;    }</div><div class="line"><a name="l01690"></a><span class="lineno"> 1690</span>&#160;</div><div class="line"><a name="l01732"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae855b7d395bd60c6072a655c57edb79d"> 1732</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae855b7d395bd60c6072a655c57edb79d">executeLargeUpdate</a>(String sql, <span class="keywordtype">int</span> columnIndexes[]) <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01733"></a><span class="lineno"> 1733</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">executeLargeUpdate</a>(sql, columnIndexes);</div><div class="line"><a name="l01734"></a><span class="lineno"> 1734</span>&#160;    }</div><div class="line"><a name="l01735"></a><span class="lineno"> 1735</span>&#160;</div><div class="line"><a name="l01776"></a><span class="lineno"><a class="line" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4f3dd6a30fbf2994b53876f6cd1c0336"> 1776</a></span>&#160;    <span class="keyword">public</span> <span class="keywordtype">long</span> <a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4f3dd6a30fbf2994b53876f6cd1c0336">executeLargeUpdate</a>(String sql, String columnNames[])</div><div class="line"><a name="l01777"></a><span class="lineno"> 1777</span>&#160;            <span class="keywordflow">throws</span> SQLException {</div><div class="line"><a name="l01778"></a><span class="lineno"> 1778</span>&#160;        <span class="keywordflow">return</span> stmt.<a class="code" href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">executeLargeUpdate</a>(sql, columnNames);</div><div class="line"><a name="l01779"></a><span class="lineno"> 1779</span>&#160;    }</div><div class="line"><a name="l01780"></a><span class="lineno"> 1780</span>&#160;</div><div class="line"><a name="l01781"></a><span class="lineno"> 1781</span>&#160;    <span class="keyword">private</span> <span class="keywordtype">void</span> buildSqlWhere(StringBuilder whereBuilder, String condition) {</div><div class="line"><a name="l01782"></a><span class="lineno"> 1782</span>&#160;        <span class="keywordflow">if</span> (whereBuilder.length() == 0) {</div><div class="line"><a name="l01783"></a><span class="lineno"> 1783</span>&#160;            whereBuilder.append(<span class="stringliteral">&quot; Where &quot;</span>).append(condition);</div><div class="line"><a name="l01784"></a><span class="lineno"> 1784</span>&#160;        } <span class="keywordflow">else</span> {</div><div class="line"><a name="l01785"></a><span class="lineno"> 1785</span>&#160;            whereBuilder.append(<span class="stringliteral">&quot; And &quot;</span>).append(condition);</div><div class="line"><a name="l01786"></a><span class="lineno"> 1786</span>&#160;        }</div><div class="line"><a name="l01787"></a><span class="lineno"> 1787</span>&#160;    }</div><div class="line"><a name="l01788"></a><span class="lineno"> 1788</span>&#160;</div><div class="line"><a name="l01789"></a><span class="lineno"> 1789</span>&#160;    <span class="keyword">private</span> String buildSqlIn(String strTextWithSpliter, <span class="keywordtype">boolean</span> needAddSingleQuote) {</div><div class="line"><a name="l01790"></a><span class="lineno"> 1790</span>&#160;</div><div class="line"><a name="l01791"></a><span class="lineno"> 1791</span>&#160;        String[] temp = strTextWithSpliter.split(<span class="stringliteral">&quot;,&quot;</span>);</div><div class="line"><a name="l01792"></a><span class="lineno"> 1792</span>&#160;        StringBuilder sb = <span class="keyword">new</span> StringBuilder();</div><div class="line"><a name="l01793"></a><span class="lineno"> 1793</span>&#160;        <span class="keywordflow">for</span> (String t : temp) {</div><div class="line"><a name="l01794"></a><span class="lineno"> 1794</span>&#160;            <span class="keywordflow">if</span> (t.trim().equals(<span class="stringliteral">&quot;&quot;</span>)) {</div><div class="line"><a name="l01795"></a><span class="lineno"> 1795</span>&#160;                <span class="keywordflow">continue</span>;</div><div class="line"><a name="l01796"></a><span class="lineno"> 1796</span>&#160;            }</div><div class="line"><a name="l01797"></a><span class="lineno"> 1797</span>&#160;            <span class="keywordflow">if</span> (sb.length() == 0) {</div><div class="line"><a name="l01798"></a><span class="lineno"> 1798</span>&#160;                <span class="keywordflow">if</span> (needAddSingleQuote) {</div><div class="line"><a name="l01799"></a><span class="lineno"> 1799</span>&#160;                    sb.append(<span class="stringliteral">&quot; In(&#39;&quot;</span>).append(t).append(<span class="stringliteral">&quot;&#39;&quot;</span>);</div><div class="line"><a name="l01800"></a><span class="lineno"> 1800</span>&#160;                } <span class="keywordflow">else</span> {</div><div class="line"><a name="l01801"></a><span class="lineno"> 1801</span>&#160;                    sb.append(<span class="stringliteral">&quot; In(&quot;</span>).append(t);</div><div class="line"><a name="l01802"></a><span class="lineno"> 1802</span>&#160;                }</div><div class="line"><a name="l01803"></a><span class="lineno"> 1803</span>&#160;            } <span class="keywordflow">else</span> {</div><div class="line"><a name="l01804"></a><span class="lineno"> 1804</span>&#160;                <span class="keywordflow">if</span> (needAddSingleQuote) {</div><div class="line"><a name="l01805"></a><span class="lineno"> 1805</span>&#160;                    sb.append(<span class="stringliteral">&quot; ,&#39;&quot;</span>).append(t).append(<span class="stringliteral">&quot;&#39;&quot;</span>);</div><div class="line"><a name="l01806"></a><span class="lineno"> 1806</span>&#160;                } <span class="keywordflow">else</span> {</div><div class="line"><a name="l01807"></a><span class="lineno"> 1807</span>&#160;                    sb.append(<span class="stringliteral">&quot; ,&quot;</span>).append(t);</div><div class="line"><a name="l01808"></a><span class="lineno"> 1808</span>&#160;                }</div><div class="line"><a name="l01809"></a><span class="lineno"> 1809</span>&#160;            }</div><div class="line"><a name="l01810"></a><span class="lineno"> 1810</span>&#160;        }</div><div class="line"><a name="l01811"></a><span class="lineno"> 1811</span>&#160;        <span class="keywordflow">if</span> (sb.length() &gt; 0) {</div><div class="line"><a name="l01812"></a><span class="lineno"> 1812</span>&#160;            sb.append(<span class="stringliteral">&quot;)&quot;</span>);</div><div class="line"><a name="l01813"></a><span class="lineno"> 1813</span>&#160;        }</div><div class="line"><a name="l01814"></a><span class="lineno"> 1814</span>&#160;        <span class="keywordflow">return</span> sb.toString();</div><div class="line"><a name="l01815"></a><span class="lineno"> 1815</span>&#160;    }</div><div class="line"><a name="l01816"></a><span class="lineno"> 1816</span>&#160;}</div><div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a1d2ec18e122dcc8e7f12b0c561ffab17"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a1d2ec18e122dcc8e7f12b0c561ffab17">org.dbcloud.jdbc.Statement.clearWarnings</a></div><div class="ttdeci">void clearWarnings()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00624">Statement.java:624</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a2bff6ca86fe1ed08d3a52ade6b1b7240"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a2bff6ca86fe1ed08d3a52ade6b1b7240">org.dbcloud.jdbc.Statement.SUCCESS_NO_INFO</a></div><div class="ttdeci">int SUCCESS_NO_INFO</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01009">Statement.java:1009</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a5fc6ab488a578bd789a94108e5c21c9f"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a5fc6ab488a578bd789a94108e5c21c9f">org.dbcloud.jdbc.Statement.execute</a></div><div class="ttdeci">boolean execute(String sql, int autoGeneratedKeys)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01264">Statement.java:1264</a></div></div>
<div class="ttc" id="namespaceorg_1_1dbcloud_html"><div class="ttname"><a href="namespaceorg_1_1dbcloud.html">org.dbcloud</a></div><div class="ttdef"><b>Definition:</b> <a href="file_servlet_8java_source.html#l00006">fileServlet.java:6</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_ae855b7d395bd60c6072a655c57edb79d"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae855b7d395bd60c6072a655c57edb79d">org.dbcloud.jdbc.Statement.executeLargeUpdate</a></div><div class="ttdeci">long executeLargeUpdate(String sql, int columnIndexes[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01732">Statement.java:1732</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_abffb2fa787f9c6d14484a8d545c4a161"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#abffb2fa787f9c6d14484a8d545c4a161">org.dbcloud.jdbc.Statement.CLOSE_ALL_RESULTS</a></div><div class="ttdeci">int CLOSE_ALL_RESULTS</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01001">Statement.java:1001</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_ae56b5f32aeed201dc64139f130627215"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ae56b5f32aeed201dc64139f130627215">org.dbcloud.jdbc.Statement.executeUpdate</a></div><div class="ttdeci">int executeUpdate(String sql, int columnIndexes[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01174">Statement.java:1174</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a512de102a58c6c8de79d0e7c3a1a1586"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a512de102a58c6c8de79d0e7c3a1a1586">org.dbcloud.jdbc.Statement.getGeneratedKeys</a></div><div class="ttdeci">org.dbcloud.jdbc.ResultSet getGeneratedKeys()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01092">Statement.java:1092</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a04d00ffd335a8da75bf6dc51f4913f88"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a04d00ffd335a8da75bf6dc51f4913f88">org.dbcloud.jdbc.Statement.executeLargeBatch</a></div><div class="ttdeci">long [] executeLargeBatch()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01606">Statement.java:1606</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a266653054fac9255337fba5c1460ae75"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a266653054fac9255337fba5c1460ae75">org.dbcloud.jdbc.Statement.setMaxFieldSize</a></div><div class="ttdeci">void setMaxFieldSize(int max)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00468">Statement.java:468</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html">org.dbcloud.jdbc.Statement</a></div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00036">Statement.java:36</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_ad9a6cb92f183850a7d06973be471e177"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ad9a6cb92f183850a7d06973be471e177">org.dbcloud.jdbc.Statement.setLargeMaxRows</a></div><div class="ttdeci">void setLargeMaxRows(long max)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01525">Statement.java:1525</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a9dda16f528c3730e94d251457e353956"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9dda16f528c3730e94d251457e353956">org.dbcloud.jdbc.Statement.getLargeUpdateCount</a></div><div class="ttdeci">long getLargeUpdateCount()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01502">Statement.java:1502</a></div></div>
<div class="ttc" id="namespaceorg_html"><div class="ttname"><a href="namespaceorg.html">org</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a62eea46adeee8609b3e1a47e11aa5870"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a62eea46adeee8609b3e1a47e11aa5870">org.dbcloud.jdbc.Statement.setMaxRows</a></div><div class="ttdeci">void setMaxRows(int max)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00500">Statement.java:500</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a359f46332a878d72379bf963e9ee2ffe"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a359f46332a878d72379bf963e9ee2ffe">org.dbcloud.jdbc.Statement.getResultSet</a></div><div class="ttdeci">org.dbcloud.jdbc.ResultSet getResultSet()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00711">Statement.java:711</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a43715d383be3fb5d2ee030668bfc6221"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43715d383be3fb5d2ee030668bfc6221">org.dbcloud.jdbc.Statement.getResultSetConcurrency</a></div><div class="ttdeci">int getResultSetConcurrency()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00850">Statement.java:850</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_adb34cc908e3ce0eb251f82d61172dce8"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adb34cc908e3ce0eb251f82d61172dce8">org.dbcloud.jdbc.Statement.cancel</a></div><div class="ttdeci">void cancel()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00585">Statement.java:585</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a982c5f8902932b29d8de9dee0d57e275"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a982c5f8902932b29d8de9dee0d57e275">org.dbcloud.jdbc.Statement.getMoreResults</a></div><div class="ttdeci">boolean getMoreResults(int current)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01069">Statement.java:1069</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a910dad307d541945796b5c9cc20331f0"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a910dad307d541945796b5c9cc20331f0">org.dbcloud.jdbc.Statement.getResultSetHoldability</a></div><div class="ttdeci">int getResultSetHoldability()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01385">Statement.java:1385</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a41f483314ed5dcbc787a74bb824eb3ad"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a41f483314ed5dcbc787a74bb824eb3ad">org.dbcloud.jdbc.Statement.execute</a></div><div class="ttdeci">boolean execute(String sql, int columnIndexes[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01317">Statement.java:1317</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a02375dec95831d0c7d2f4879d2502110"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a02375dec95831d0c7d2f4879d2502110">org.dbcloud.jdbc.Statement.setCursorName</a></div><div class="ttdeci">void setCursorName(String name)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00652">Statement.java:652</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a83555b48c31cedeff650c3688eb18a98"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a83555b48c31cedeff650c3688eb18a98">org.dbcloud.jdbc.Statement.executeBatch</a></div><div class="ttdeci">int [] executeBatch()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00960">Statement.java:960</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a158b6739f9b0b40fa61ebf9e5447fbec"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a158b6739f9b0b40fa61ebf9e5447fbec">org.dbcloud.jdbc.Statement.execute</a></div><div class="ttdeci">boolean execute(String sql, String columnNames[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01370">Statement.java:1370</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a74ee124d251a1785b5ee72461d992cee"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a74ee124d251a1785b5ee72461d992cee">org.dbcloud.jdbc.Statement.getMaxFieldSize</a></div><div class="ttdeci">int getMaxFieldSize()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00445">Statement.java:445</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a43ca3bf24baedb67bf63710ff837f72d"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a43ca3bf24baedb67bf63710ff837f72d">org.dbcloud.jdbc.Statement.getMoreResults</a></div><div class="ttdeci">boolean getMoreResults()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00758">Statement.java:758</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_afb6b2eeae90afbd7fdecf399cda5a9eb"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afb6b2eeae90afbd7fdecf399cda5a9eb">org.dbcloud.jdbc.Statement.getConnection</a></div><div class="ttdeci">String getConnection()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00973">Statement.java:973</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a9015df745c62b658704417ff162bf981"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9015df745c62b658704417ff162bf981">org.dbcloud.jdbc.Statement.setEscapeProcessing</a></div><div class="ttdeci">void setEscapeProcessing(boolean enable)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00526">Statement.java:526</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_aebe85c4f946f983a1e36b816f999f4a3"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aebe85c4f946f983a1e36b816f999f4a3">org.dbcloud.jdbc.Statement.isPoolable</a></div><div class="ttdeci">boolean isPoolable()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01444">Statement.java:1444</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_afc1d222a53d4503e85fb86a05e7e5985"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afc1d222a53d4503e85fb86a05e7e5985">org.dbcloud.jdbc.Statement.executeUpdate</a></div><div class="ttdeci">int executeUpdate(String sql, String columnNames[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01212">Statement.java:1212</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_acfa84224f98ccf395c3568a0f882eb35"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acfa84224f98ccf395c3568a0f882eb35">org.dbcloud.jdbc.Statement.EXECUTE_FAILED</a></div><div class="ttdeci">int EXECUTE_FAILED</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01017">Statement.java:1017</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a08d8bad6ab34257c4d0a110c36a78616"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a08d8bad6ab34257c4d0a110c36a78616">org.dbcloud.jdbc.Statement.getMaxRows</a></div><div class="ttdeci">int getMaxRows()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00484">Statement.java:484</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_aa80c2e0e1085aac839151b8872e16993"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#aa80c2e0e1085aac839151b8872e16993">org.dbcloud.jdbc.Statement.close</a></div><div class="ttdeci">void close()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00423">Statement.java:423</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_af006516e861bd5dff0e24771dec1abe4"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#af006516e861bd5dff0e24771dec1abe4">org.dbcloud.jdbc.Statement.addBatch</a></div><div class="ttdeci">void addBatch(String sql)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00887">Statement.java:887</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a453afff67167062d34d5780538ff0c55"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a453afff67167062d34d5780538ff0c55">org.dbcloud.jdbc.Statement.executeLargeUpdate</a></div><div class="ttdeci">long executeLargeUpdate(String sql, int autoGeneratedKeys)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01686">Statement.java:1686</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_ac0ebb00942f335fd306d6f0e7e8b09c5"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#ac0ebb00942f335fd306d6f0e7e8b09c5">org.dbcloud.jdbc.Statement.getUpdateCount</a></div><div class="ttdeci">int getUpdateCount()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00734">Statement.java:734</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a0e6028a45786c2efbddc440852a0afc7"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a0e6028a45786c2efbddc440852a0afc7">org.dbcloud.jdbc.Statement.executeUpdate</a></div><div class="ttdeci">int executeUpdate(String sql, int autoGeneratedKeys)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01139">Statement.java:1139</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_adc015a991c336f0edea9e26c0de37027"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#adc015a991c336f0edea9e26c0de37027">org.dbcloud.jdbc.Statement.setPoolable</a></div><div class="ttdeci">void setPoolable(boolean poolable)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01425">Statement.java:1425</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a743ed7694dd8a9a67b2c23319db6ca3e"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a743ed7694dd8a9a67b2c23319db6ca3e">org.dbcloud.jdbc.Statement.getResultSetType</a></div><div class="ttdeci">int getResultSetType()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00865">Statement.java:865</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a4f3dd6a30fbf2994b53876f6cd1c0336"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4f3dd6a30fbf2994b53876f6cd1c0336">org.dbcloud.jdbc.Statement.executeLargeUpdate</a></div><div class="ttdeci">long executeLargeUpdate(String sql, String columnNames[])</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01776">Statement.java:1776</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a09a3a60330f32ae3182494583e4bb18a"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a09a3a60330f32ae3182494583e4bb18a">org.dbcloud.jdbc.Statement.getQueryTimeout</a></div><div class="ttdeci">int getQueryTimeout()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00541">Statement.java:541</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a051e2b3838be606adc522d173d4978f8"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a051e2b3838be606adc522d173d4978f8">org.dbcloud.jdbc.Statement.executeQuery</a></div><div class="ttdeci">org.dbcloud.jdbc.ResultSet executeQuery(String sql)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00172">Statement.java:172</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a8074a7dca69e29eeac5c5db676588b5f"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a8074a7dca69e29eeac5c5db676588b5f">org.dbcloud.jdbc.Statement.closeOnCompletion</a></div><div class="ttdeci">void closeOnCompletion()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01465">Statement.java:1465</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_result_set_html"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_result_set.html">org.dbcloud.jdbc.ResultSet</a></div><div class="ttdef"><b>Definition:</b> <a href="_result_set_8java_source.html#l00015">ResultSet.java:15</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_acf23cba800d36c519344e01581aedc9f"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#acf23cba800d36c519344e01581aedc9f">org.dbcloud.jdbc.Statement.KEEP_CURRENT_RESULT</a></div><div class="ttdeci">int KEEP_CURRENT_RESULT</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00992">Statement.java:992</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_afa7b4b2c3acd383591999842acb0d6c3"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afa7b4b2c3acd383591999842acb0d6c3">org.dbcloud.jdbc.Statement.CLOSE_CURRENT_RESULT</a></div><div class="ttdeci">int CLOSE_CURRENT_RESULT</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00984">Statement.java:984</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a401b7cbfca595b070210b0e8672c2b56"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a401b7cbfca595b070210b0e8672c2b56">org.dbcloud.jdbc.Statement.setFetchSize</a></div><div class="ttdeci">void setFetchSize(int rows)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00818">Statement.java:818</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a9427303d199c8b15f023c2e5746f7a03"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9427303d199c8b15f023c2e5746f7a03">org.dbcloud.jdbc.Statement.clearBatch</a></div><div class="ttdeci">void clearBatch()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00902">Statement.java:902</a></div></div>
<div class="ttc" id="namespaceorg_1_1dbcloud_1_1jdbc_html"><div class="ttname"><a href="namespaceorg_1_1dbcloud_1_1jdbc.html">org.dbcloud.jdbc</a></div><div class="ttdef"><b>Definition:</b> <a href="_result_set_8java_source.html#l00006">ResultSet.java:6</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a29c2090bbc4b542346d008011a12218b"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a29c2090bbc4b542346d008011a12218b">org.dbcloud.jdbc.Statement.getLargeMaxRows</a></div><div class="ttdeci">long getLargeMaxRows()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01547">Statement.java:1547</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a38206e2c79afc6ce964f1b058c20d12f"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a38206e2c79afc6ce964f1b058c20d12f">org.dbcloud.jdbc.Statement.getFetchDirection</a></div><div class="ttdeci">int getFetchDirection()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00800">Statement.java:800</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a348a9c2612c65ebc810d3f043f382766"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a348a9c2612c65ebc810d3f043f382766">org.dbcloud.jdbc.Statement.RETURN_GENERATED_KEYS</a></div><div class="ttdeci">int RETURN_GENERATED_KEYS</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01025">Statement.java:1025</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a087e427a28516cd24605e04e395565b2"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a087e427a28516cd24605e04e395565b2">org.dbcloud.jdbc.Statement.execute</a></div><div class="ttdeci">boolean execute(String sql)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00688">Statement.java:688</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_afe5aa6911f700fbe2437ac7a62abf507"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#afe5aa6911f700fbe2437ac7a62abf507">org.dbcloud.jdbc.Statement.setQueryTimeout</a></div><div class="ttdeci">void setQueryTimeout(int seconds)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00571">Statement.java:571</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a89f1107e302fe54f9378eca67d7a8cb1"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a89f1107e302fe54f9378eca67d7a8cb1">org.dbcloud.jdbc.Statement.executeUpdate</a></div><div class="ttdeci">int executeUpdate(String sql)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00397">Statement.java:397</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a4e6170daf48535ddaff70a77c701acdc"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a4e6170daf48535ddaff70a77c701acdc">org.dbcloud.jdbc.Statement.NO_GENERATED_KEYS</a></div><div class="ttdeci">int NO_GENERATED_KEYS</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01033">Statement.java:1033</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a005f0da4c3d9beb59caa27fbb6fe02c3"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a005f0da4c3d9beb59caa27fbb6fe02c3">org.dbcloud.jdbc.Statement.executeProcedure</a></div><div class="ttdeci">org.dbcloud.jdbc.ResultSet executeProcedure(String procedureName, Document parameters, Document options)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00243">Statement.java:243</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a63fddc3f05f3ecf12cf3f13a413888ea"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a63fddc3f05f3ecf12cf3f13a413888ea">org.dbcloud.jdbc.Statement.setFetchDirection</a></div><div class="ttdeci">void setFetchDirection(int direction)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00782">Statement.java:782</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a37fe1abd43d17fd845faa1925170e99a"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a37fe1abd43d17fd845faa1925170e99a">org.dbcloud.jdbc.Statement.getFetchSize</a></div><div class="ttdeci">int getFetchSize()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l00836">Statement.java:836</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a238a99b288bf216e85c15ef4f5146afb"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a238a99b288bf216e85c15ef4f5146afb">org.dbcloud.jdbc.Statement.isClosed</a></div><div class="ttdeci">boolean isClosed()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01399">Statement.java:1399</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a9622ab3704dc0ae68738738b32a7a99a"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a9622ab3704dc0ae68738738b32a7a99a">org.dbcloud.jdbc.Statement.executeLargeUpdate</a></div><div class="ttdeci">long executeLargeUpdate(String sql)</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01641">Statement.java:1641</a></div></div>
<div class="ttc" id="classorg_1_1dbcloud_1_1jdbc_1_1_statement_html_a631da85a6cab87cfac1920fa97df3abd"><div class="ttname"><a href="classorg_1_1dbcloud_1_1jdbc_1_1_statement.html#a631da85a6cab87cfac1920fa97df3abd">org.dbcloud.jdbc.Statement.isCloseOnCompletion</a></div><div class="ttdeci">boolean isCloseOnCompletion()</div><div class="ttdef"><b>Definition:</b> <a href="jdbc_2_statement_8java_source.html#l01479">Statement.java:1479</a></div></div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li class="navelem"><a class="el" href="dir_a3016bf19aa28451207b266e9b24d523.html">java</a></li><li class="navelem"><a class="el" href="dir_d898fe37fb7e20b388db820abf3aca5d.html">org</a></li><li class="navelem"><a class="el" href="dir_2cfdf83c0ba633d26e251fcc1db301cc.html">dbcloud</a></li><li class="navelem"><a class="el" href="dir_2ae3438efe1190205d4abb1048040c41.html">jdbc</a></li><li class="navelem"><b>Statement.java</b></li>
    <li class="footer">Generated by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.13 </li>
  </ul>
</div>
</body>
</html>
